--Api 表
/*
select * from SYS_Apis
select * from SYS_ApiM --M  Memo Main Manage

ReturnType
返回类型（类似返回值）
1 execSql 
2 openSql
3 execProc(不带返回结果) 
4 openProc(带返回结果集)
5 getList (使用getList sql 模板)
*/

declare 
  @ApiName varchar(50)='sjdg.sheets',
  @ReturnType int =5
--
--
delete from SYS_Apis where ApiName=@ApiName
delete from SYS_ApiM where apiName=@ApiName
insert into SYS_ApiM([apiName],[name],[memo])
select @ApiName,'底稿分配，底稿Sheet页','底稿分配，底稿Sheet页,非excel的直接返回底稿信息'
insert into SYS_Apis(ApiName,paramsLen,params,ReturnType,sqlText)
select @ApiName,0,
null,
@ReturnType,
'select guid,sheetName,sheetIndex,editUser,sheetVisible,bzwc
from [#(dbname)]..sjdgSheet where dgid=#para(dgid) and isnull(isDel,0)=0 order by sheetIndex'
